package codeCreate.util;

import java.util.List;

import org.apache.commons.lang.StringUtils;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

/** 
 * 需要用jacob-1.15-M3-x86.dll放windows/system/32下面 以及jacob.jar 
 */
public class MsWordEdit {
    // word文档
    private Dispatch doc;
    // word运行程序对象
    private ActiveXComponent word;
    // 所有word文档集合
    private Dispatch documents;
    // 选定的范围或插入点
    private Dispatch selection;
    private boolean saveOnExit = true;
    private boolean bold = false;
    private boolean italic = false;
    private boolean underLine = false;
    private String color = "";
    private String size = "";
    private String name = "";
    private int align = 0;
    private int lineSpace = 0;
    private Dispatch table;

    public MsWordEdit() {
        if (word == null) {
            word = new ActiveXComponent("Word.Application");
            word.setProperty("Visible", new Variant(false));
        }
        if (documents == null)
            documents = word.getProperty("Documents").toDispatch();
    }

    public void moveHead() {
        selection = Dispatch.get(word, "Selection").toDispatch();
    }

    /** 
     * 设置退出时参数 
     * 
     * @param saveOnExit 
     * boolean true-退出时保存文件，false-退出时不保存文件 
     */
    public void setSaveOnExit(boolean saveOnExit) {
        this.saveOnExit = saveOnExit;
    }

    /** 
     * 创建一个新的word文档 
     */
    public void createNewDocument() {
        doc = Dispatch.call(documents, "Add").toDispatch();
        selection = Dispatch.get(word, "Selection").toDispatch();
    }

    /** 
     * 打开一个已存在的文档 
     * @param docPath 
     */
    public void openDocument(String docPath) {
        closeDocument();
        doc = Dispatch.call(documents, "Open", docPath).toDispatch();
        selection = Dispatch.get(word, "Selection").toDispatch();
    }

    /** 
     * 把选定的内容或插入点向上移动 
     * @param pos  移动的距离 
     */
    public void moveUp(int pos) {
        if (selection == null)
            selection = Dispatch.get(word, "Selection").toDispatch();
        for (int i = 0; i < pos; i++)
            Dispatch.call(selection, "MoveUp");
    }

    /** 
     * 把选定的内容或者插入点向下移动 
     * @param pos  移动的距离 
     */
    public void moveDown(int pos) {
        if (selection == null)
            selection = Dispatch.get(word, "Selection").toDispatch();
        for (int i = 0; i < pos; i++)
            Dispatch.call(selection, "MoveDown");
    }

    /** 
     * 把选定的内容或者插入点向左移动 
     * @param pos  移动的距离 
     */
    public void moveLeft(int pos) {
        if (selection == null)
            selection = Dispatch.get(word, "Selection").toDispatch();
        for (int i = 0; i < pos; i++) {
            Dispatch.call(selection, "MoveLeft");
        }
    }

    /** 
     * 把选定的内容或者插入点向右移动 
     * @param pos 移动的距离 
     */
    public void moveRight(int pos) {
        if (selection == null)
            selection = Dispatch.get(word, "Selection").toDispatch();
        for (int i = 0; i < pos; i++)
            Dispatch.call(selection, "MoveRight");
    }

    /** 
    * 把插入点移动到文件首位置 
    */
    public void moveStart() {
        if (selection == null)
            selection = Dispatch.get(word, "Selection").toDispatch();
        Dispatch.call(selection, "HomeKey", new Variant(6));
    }

    /** 
     * 从选定内容或插入点开始查找文本 
     * 
     * @param toFindText 要查找的文本 
     * @return boolean true-查找到并选中该文本，false-未查找到文本 
     */
    public boolean find(String toFindText) {
        if (toFindText == null || toFindText.equals(""))
            return false;
        // 从selection所在位置开始查询
        Dispatch find = word.call(selection, "Find").toDispatch();
        // 设置要查找的内容
        Dispatch.put(find, "Text", toFindText);
        // 向前查找
        Dispatch.put(find, "Forward", "True");
        // 设置格式
        Dispatch.put(find, "Format", "True");
        // 大小写匹配
        Dispatch.put(find, "MatchCase", "True");
        // 全字匹配
        Dispatch.put(find, "MatchWholeWord", "True");
        // 查找并选中
        return Dispatch.call(find, "Execute").getBoolean();
    }

    /** 
     * 把选定选定内容设定为替换文本 
     * @param toFindText 查找字符串 
     * @param newText 要替换的内容 
     * @return 
     */
    public boolean replaceText(String toFindText, String newText) {
        if (!find(toFindText))
            return false;
        Dispatch.put(selection, "Text", newText);
        return true;
    }

    /** 
     * 全局替换文本 
     * @param toFindText 查找字符串 
     * @param newText 要替换的内容 
     */
    public void replaceAllText(String toFindText, String newText) {
        while (find(toFindText)) {
            Dispatch.put(selection, "Text", newText);
            Dispatch.call(selection, "MoveRight");
        }
    }

    public void replaceTextOne(String toFindText, String newText) {
        if (find(toFindText)) {
            Dispatch.put(selection, "Text", newText);
            Dispatch.call(selection, "MoveRight");
        }
    }

    /** 
     * 在当前插入点插入字符串 
     * @param newText 要插入的新字符串 
     */
    public void insertText(String newText) {
        Dispatch.put(selection, "Text", newText);
    }

    /** 
     * 
     * @param toFindText 要查找的字符串 
     * @param imagePath 图片路径 
     * @return 
     */
    public boolean replaceImage(String toFindText, String imagePath) {
        if (!find(toFindText))
            return false;
        Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
        return true;
    }

    /** 
     * 全局替换图片 
     * @param toFindText 查找字符串 
     * @param imagePath 图片路径 
     */
    public void replaceAllImage(String toFindText, String imagePath) {
        while (find(toFindText)) {
            Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
            Dispatch.call(selection, "MoveRight");
        }
    }

    /** 
     * 在当前插入点插入图片 
     * @param imagePath 图片路径 
     */
    public void insertImage(String imagePath) {
        Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
    }

    /** 
     * 合并单元格 
     * @param tableIndex 
     * @param fstCellRowIdx 
     * @param fstCellColIdx 
     * @param secCellRowIdx 
     * @param secCellColIdx 
     */
    public void mergeCell(int tableIndex, int fstCellRowIdx, int fstCellColIdx, int secCellRowIdx, int secCellColIdx) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch fstCell = Dispatch.call(table, "Cell", new Variant(fstCellRowIdx), new Variant(fstCellColIdx))
                .toDispatch();
        Dispatch secCell = Dispatch.call(table, "Cell", new Variant(secCellRowIdx), new Variant(secCellColIdx))
                .toDispatch();
        Dispatch.call(fstCell, "Merge", secCell);
    }

    /** 
     * 得到指定单元格的值 
     * 
     * @param tableIndex 
     * @param cellRowIdx 
     * @param cellColIdx 
     */
    public String getTxtFromCell(int tableIndex, int cellRowIdx, int cellColIdx) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
        Dispatch.call(cell, "Select");
        return StringUtils.trim(Dispatch.get(selection, "Text").toString());
    }

    /** 
     * 在当前文档指定的位置拷贝表格 
     * @param pos 当前文档指定的位置 
     * @param tableIndex 被拷贝的表格在word文档中所处的位置 
     */
    public void copyTable(String pos, int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch range = Dispatch.get(table, "Range").toDispatch();
        Dispatch.call(range, "Copy");
        if (this.find(pos)) {
            Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
            Dispatch.call(textRange, "Paste");
        }
    }

    /** 
     * 在当前文档指定的位置拷贝来自另一个文档中的表格 
     * @param anotherDocPath 另一个文档的磁盘路径 
     * @param tableIndex 被拷贝的表格在另一格文档中的位置 
     * @param pos  当前文档指定的位置 
     */
    public void copyTableFromAnotherDoc(String anotherDocPath, int tableIndex, String pos) {
        Dispatch doc2 = null;
        try {
            doc2 = Dispatch.call(documents, "Open", anotherDocPath).toDispatch();
            // 所有表格
            Dispatch tables = Dispatch.get(doc2, "Tables").toDispatch();
            // 要填充的表格
            Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
            Dispatch range = Dispatch.get(table, "Range").toDispatch();
            Dispatch.call(range, "Copy");
            if (this.find(pos)) {
                Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
                Dispatch.call(textRange, "Paste");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (doc2 != null) {
                Dispatch.call(doc2, "Close", new Variant(saveOnExit));
                doc2 = null;
            }
        }
    }

    /** 
     * 在当前文档指定的位置拷贝来自另一个文档中的图片 
     * @param anotherDocPath 另一个文档的磁盘路径 
     * @param shapeIndex 被拷贝的图片在另一格文档中的位置 
     * @param pos 当前文档指定的位置 
     */
    public void copyImageFromAnotherDoc(String anotherDocPath, int shapeIndex, String pos) {
        Dispatch doc2 = null;
        try {
            doc2 = Dispatch.call(documents, "Open", anotherDocPath).toDispatch();
            Dispatch shapes = Dispatch.get(doc2, "InLineShapes").toDispatch();
            Dispatch shape = Dispatch.call(shapes, "Item", new Variant(shapeIndex)).toDispatch();
            Dispatch imageRange = Dispatch.get(shape, "Range").toDispatch();
            Dispatch.call(imageRange, "Copy");
            if (this.find(pos)) {
                Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
                Dispatch.call(textRange, "Paste");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (doc2 != null) {
                Dispatch.call(doc2, "Close", new Variant(saveOnExit));
                doc2 = null;
            }
        }
    }

    /** 
     * 创建表格 
     * @param pos 位置 
     * @param cols 列数 
     * @param rows 行数 
     */
    public void createTable(String pos, int numRows, int numCols, float lineWidth, int rowHeight) {
        Dispatch newTable = null;
        if (find(pos)) {
            Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
            Dispatch range = Dispatch.get(selection, "Range").toDispatch();
            newTable = Dispatch.call(tables, "Add", range, new Variant(numRows), new Variant(numCols)).toDispatch();
            Dispatch.call(selection, "MoveRight");
        } else {
            Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
            Dispatch range = Dispatch.get(selection, "Range").toDispatch();
            newTable = Dispatch.call(tables, "Add", range, new Variant(numRows), new Variant(numCols)).toDispatch();
            Dispatch.call(selection, "MoveRight");
        }
        this.table = newTable;
        Dispatch borders = Dispatch.get(newTable, "Borders").toDispatch();
        Dispatch border = null;
        for (int i = 1; i < 7; i++) {
            border = Dispatch.call(borders, "Item", new Variant(i)).toDispatch();
            if (lineWidth != 0) {
                Dispatch.put(border, "LineWidth", new Variant(lineWidth));
                Dispatch.put(border, "Visible", new Variant(true));
            } else if (lineWidth == 0) {
                Dispatch.put(border, "Visible", new Variant(false));
            }
        }
        // 设置行高
        Dispatch rows = Dispatch.get(newTable, "Rows").toDispatch();
        while (numRows > 0) {
            Dispatch row = Dispatch.call(rows, "Item", new Variant(numRows)).toDispatch();
            Dispatch.put(row, "Height", new Variant(rowHeight));
            numRows--;
        }
    }

    public void setTableRowGroundColor(int tableIndex, int rowIndex, String color) {
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.call(rows, "Item", new Variant(rowIndex)).toDispatch();
        Dispatch shading = Dispatch.get(row, "Shading").toDispatch();
        Dispatch.put(shading, "BackgroundPatternColor", color);
    }

    public void setTableColGroundColor(int tableIndex, int columnIndex, String color) {
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch rows = Dispatch.get(table, "Columns").toDispatch();
        Dispatch row = Dispatch.call(rows, "Item", new Variant(columnIndex)).toDispatch();
        Dispatch shading = Dispatch.get(row, "Shading").toDispatch();
        Dispatch.put(shading, "BackgroundPatternColor", color);
    }

    public void setTableWidth(int tableIndex, int columnIndex, int width) {
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch columns = Dispatch.get(table, "Columns").toDispatch();
        Dispatch column = Dispatch.call(columns, "Item", new Variant(columnIndex)).toDispatch();
        Dispatch.put(column, "Width", new Variant(width));
    }

    public void setTableHeight(int tableIndex, int rowIndex, int height) {
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.call(rows, "Item", new Variant(rowIndex)).toDispatch();
        Dispatch.put(row, "Height", new Variant(height));
    }

    /** 
     * 在指定行前面增加行 
     * @param tableIndex word文件中的第N张表(从1开始) 
     * @param rowIndex 指定行的序号(从1开始) 
     */
    public void addTableRow(int tableIndex, int rowIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.call(rows, "Item", new Variant(rowIndex)).toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /** 
     * 自动调整表格 
     * 
     */
    public void autoFitTable() {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        int count = Dispatch.get(tables, "Count").toInt();
        for (int i = 0; i < count; i++) {
            Dispatch table = Dispatch.call(tables, "Item", new Variant(i + 1)).toDispatch();
            Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
            Dispatch.call(cols, "AutoFit");
        }
    }

    /** 
     * 调用word里的宏以调整表格的宽度,其中宏保存在document下 
     * 
     */
    public void callWordMacro() {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        int count = Dispatch.get(tables, "Count").toInt();
        Variant vMacroName = new Variant("Normal.NewMacros.tableFit");
        Variant vParam = new Variant("param1");
        Variant para[] = new Variant[] { vMacroName };
        for (int i = 0; i < count; i++) {
            Dispatch table = Dispatch.call(tables, "Item", new Variant(i + 1)).toDispatch();
            Dispatch.call(table, "Select");
            Dispatch.call(word, "Run", "tableFitContent");
        }
    }

    /** 
     * 文件保存或另存为 
     * 
     * @param savePath 保存或另存为路径 
     */
    public void save(String savePath) {
        Dispatch.call(Dispatch.call(word, "WordBasic").getDispatch(), "FileSaveAs", savePath);
    }

    /** 
     * 关闭文档 
     *@param val 0不保存修改 -1 保存修改 -2 提示是否保存修改 
     */
    public void closeDocument(int val) {
        Dispatch.call(doc, "Close", new Variant(val));
        doc = null;
    }

    /** 
     * 关闭当前word文档 
     * 
     */
    public void closeDocument() {
        if (doc != null) {
            Dispatch.call(doc, "Save");
            Dispatch.call(doc, "Close", new Variant(saveOnExit));
            doc = null;
        }
    }

    /** 
     * 关闭全部应用 
     * 
     */
    public void close() {
        if (word != null) {
            Dispatch.call(word, "Quit");
            word = null;
        }
        selection = null;
        documents = null;
    }

    /** 
     * 打印当前word文档 
     * 
     */
    public void printFile() {
        if (doc != null) {
            Dispatch.call(doc, "PrintOut");
        }
    }

    public static boolean replaceWordText(String docPath, String modifysavePath, String bookMark, String replaceWord) {
        MsWordEdit msWordManager = new MsWordEdit();
        try {
            msWordManager.openDocument(docPath);
            msWordManager.save(modifysavePath);
            msWordManager.closeDocument(0);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            msWordManager.close();
        }
        return true;
    }

    /** */
    /**
     * 在指定的单元格里填写数据
     * 
     * @param tableIndex
     *            文档中的第tIndex个Table，即tIndex为索引取
     * @param cellRowIdx
     *            cell在Table第row行
     * @param cellColIdx
     *            cell在Talbe第col列
     * @param txt
     *            填写的数据
     */
    public void moveToCell(int tableIndex, int cellRowIdx, int cellColIdx) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
        Dispatch.call(cell, "Select");
        Dispatch.call(selection, "MoveRight");
    }

    /**
     * 插入分节符
     */
    public void InsertBreakNextPage() {
        Dispatch.call(word, "Run", new Variant("InsertBreakWdSectionBreakNextPage"));
    }

    /**
     * 新增分页符
     */
    public void InsertBreak() {
        Dispatch.call(selection, "InsertBreak", new Variant(7));
    }

    /**
     * 换行符
     */
    public void Enter() {
        Dispatch.call(selection, "EndKey", "5");
        Dispatch.call(selection, "TypeParagraph");
    }

    /**
     * 换多行
    * @param line
     */
    public void Enter(int line) {
        while (line > 0) {
            Dispatch.call(selection, "EndKey", "5");
            Dispatch.call(selection, "TypeParagraph");
            line--;
        }
    }

    /** */
    /**
     * 在指定的单元格里填写数据
     * 
     * @param tableIndex
     *            文档中的第tIndex个Table，即tIndex为索引取
     * @param cellRowIdx
     *            cell在Table第row行
     * @param cellColIdx
     *            cell在Talbe第col列
     * @param txt
     *            填写的数据
     */
    public void putTxtToCell(int tableIndex, int cellRowIdx, int cellColIdx, String txt, int rowNumber, int colNumber) {
        // 所有表格
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
        Dispatch.call(cell, "Select");
        Dispatch.put(selection, "Text", txt);
        moveDown(rowNumber - cellRowIdx + 1);
        moveRight(colNumber - cellColIdx + 1);
    }

    /** */
    /**
     * 在指定的单元格里填写数据
     * 
     * @param tableIndex
     * @param cellRowIdx
     * @param cellColIdx
     * @param txt
     */
    public void putTxtToCellHead(int tableIndex, int cellRowIdx, int cellColIdx, String txt, String fontColor,
            String fontSize, String fontName) {
        // 所有表格
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
        Dispatch.call(cell, "Select");
        this.setParaFormatLocal(1, 0);
        this.setFontLocal(true, false, false, fontColor, fontSize, fontName);
        Dispatch.put(selection, "Text", txt);
        moveRight(1);
        this.setParaFormatLocal(align, lineSpace);
        this.setFont(bold, italic, underLine, color, size, name);
    }

    /** */
    /**
     * 在指定的单元格行列表里填写数据
     * 
     * @param tableIndex
     * @param cellRowIdx
     * @param cellColIdx
     * @param txt
     */
    public void putTxtToCellHeadRow(int tableIndex, int cellRowIdx, int cellColIdx, String[] txts, int rowsNum,
            int colNum, String fontColor, String fontSize, String fontName) {
        // 所有表格
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        setFontLocal(true, false, false, fontColor, fontSize, fontName);
        for (int i = 0; i < txts.length; i++) {
            Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx + i), new Variant(cellColIdx))
                    .toDispatch();
            Dispatch.call(cell, "Select");
            Dispatch.put(selection, "Text", txts[i]);
            setParaFormatLocal(1, 3);
        }
        moveDown(rowsNum + 1);
        moveRight(colNum + 1);
        Enter();
        setParaFormatLocal(align, lineSpace);
        setFont(bold, italic, underLine, color, size, name);
    }

    /** */
    /**
     * 在指定的单元格列列表里填写数据
     * 
     * @param tableIndex
     * @param cellRowIdx
     * @param cellColIdx
     * @param txt
     */
    public void putTxtToCellHeadCol(int tableIndex, int cellRowIdx, int cellColIdx, String[] txts, int rowsNum,
            int colNum, String fontColor, String fontSize, String fontName) {
        // 所有表格
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        setFontLocal(true, false, false, fontColor, fontSize, fontName);
        for (int i = 0; i < txts.length; i++) {
            Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx + i))
                    .toDispatch();
            Dispatch.call(cell, "Select");
            Dispatch.put(selection, "Text", txts[i]);
            setParaFormatLocal(1, 3);
        }
        moveDown(rowsNum + 1);
        moveRight(colNum + 1);
        Enter();
        setParaFormatLocal(align, lineSpace);
        setFont(bold, italic, underLine, color, size, name);
    }

    /** */
    /**
     * 批量填入数据到单元格中
     * 
     * @param tableIndex
     * @param cellRowIdx
     * @param cellColIdx
     * @param txt
     */
    public void putListTxtToCell(int tableIndex, int cellRowIdx, int cellColIdx, List<String[]> txtList, int rowsNum,
            int colNum, String fontColor, String fontSize, String fontName) {
        // 所有表格
        // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // // 要填充的表格
        // Dispatch table = Dispatch.call(tables, "Item", new
        // Variant(tableIndex)).toDispatch();
        setFontLocal(true, false, false, fontColor, fontSize, fontName);
        for (int j = 0; j < txtList.size(); j++) {
            String[] column = txtList.get(j);
            for (int i = 0; i < column.length; i++) {
                Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx + j), new Variant(cellColIdx + i))
                        .toDispatch();
                Dispatch.call(cell, "Select");
                Dispatch.put(selection, "Text", column[i]);
                setParaFormatLocal(1, 3);
            }
        }
        moveDown(rowsNum + 1);
        moveRight(colNum + 1);
        Enter();
        setParaFormatLocal(align, lineSpace);
        setFont(bold, italic, underLine, color, size, name);
    }

    //
    // 设置选定内容居中
    //
    // @param selectedContent
    // 所选定的内容
    //
    public void setTableCentered() {
        Dispatch.put(table, "Alignment", "1");
    }

    // public void setTableLine(int tableIndex) {
    // // 所有表格
    // Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
    // // 要填充的表格
    // Dispatch table = Dispatch.call(tables, "Item", new
    // Variant(tableIndex)).toDispatch();
    // Dispatch oBorders = Dispatch.call(table, "Borders", 1).toDispatch();
    // Dispatch.put(oBorders, "LineStyle", new Variant(1));
    // Dispatch oBorders1 = Dispatch.call(table, "Borders", 2).toDispatch();
    // Dispatch.put(oBorders1, "LineStyle", new Variant(1));
    // Dispatch oBorders2 = Dispatch.call(table, "Borders", 3).toDispatch();
    // Dispatch.put(oBorders2, "LineStyle", new Variant(1));
    // Dispatch oBorders3 = Dispatch.call(table, "Borders", 4).toDispatch();
    // Dispatch.put(oBorders3, "LineStyle", new Variant(1));
    // Dispatch oBorders4 = Dispatch.call(table, "Borders", 5).toDispatch();
    // Dispatch.put(oBorders3, "LineStyle", new Variant(1));
    // }
    //
    // 设置当前表格线的粗细 注：在调用此方法前，表格对象必须存在
    //
    // @param w
    // w范围：1<w<13,如果是0，就代表没有框
    //

    public void setTableBorderWidth(int tableIndex, float w) {
        try {
            Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
            Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
            Dispatch borders = Dispatch.get(table, "Borders").toDispatch();
            Dispatch border = null;

            //
            // 设置表格线的粗细 1：代表最上边一条线 2：代表最左边一条线 3：最下边一条线 4：最右边一条线 5：除最上边最下边之外的所有横线
            // 6：除最左边最右边之外的所有竖线 7：从左上角到右下角的斜线 8：从左下角到右上角的斜线
            //
            for (int i = 1; i < 7; i++) {
                border = Dispatch.call(borders, "Item", new Variant(i)).toDispatch();
                if (w != 0) {
                    Dispatch.put(border, "LineWidth", new Variant(w));
                    Dispatch.put(border, "Visible", new Variant(true));
                } else if (w == 0) {
                    Dispatch.put(border, "Visible", new Variant(false));
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 
     * 得到当前文档的tables集合
     */
    public Dispatch getTables() throws Exception {
        if (this.doc == null) {
            throw new Exception("there is not a document can't be operate!!!");
        }
        return Dispatch.get(doc, "Tables").toDispatch();
    }

    /**
     * 
     * 得到当前文档的表格数
     * 
     * @param Dispatch
     */
    public int getTablesCount(Dispatch tables) throws Exception {
        int count = 0;
        try {
            this.getTables();
        } catch (Exception e) {
            throw new Exception("there is not any table!!");
        }
        count = Dispatch.get(tables, "Count").getInt();
        return count;
    }

    /** */
    /**
     * 在当前文档拷贝剪贴板数据
     * 
     * @param pos
     */
    public void pasteExcelSheet(String pos) {
        moveStart();
        if (this.find(pos)) {
            Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
            Dispatch.call(textRange, "Paste");
        }
    }

    /** */
    /**
     * 在第1行前增加一行
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addFirstTableRow(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.get(rows, "First").toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /** */
    /**
     * 在最后1行前增加一行
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addLastTableRow(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.get(rows, "Last").toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /** */
    /**
     * 增加一行
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addRow(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch.call(rows, "Add");
    }

    /** */
    /**
     * 增加一列
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addCol(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch.call(cols, "Add").toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /** */
    /**
     * 在指定列前面增加表格的列
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     * @param colIndex
     *            制定列的序号 (从1开始)
     */
    public void addTableCol(int tableIndex, int colIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        System.out.println(Dispatch.get(cols, "Count"));
        Dispatch col = Dispatch.call(cols, "Item", new Variant(colIndex)).toDispatch();
        // Dispatch col = Dispatch.get(cols, "First").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /** */
    /**
     * 在第1列前增加一列
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addFirstTableCol(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch col = Dispatch.get(cols, "First").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /** */
    /**
     * 在最后一列前增加一列
     * 
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addLastTableCol(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch col = Dispatch.get(cols, "Last").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /** */
    /**
     * 设置当前选定内容的字体
     * 
     * @param boldSize
     * @param italicSize
     * @param underLineSize
     *            下划线
     * @param color
     *            字体颜色
     * @param size
     *            字体大小
     * @param name
     *            字体名称
     */
    public void setFont(boolean bold, boolean italic, boolean underLine, String color, String size, String name) {
        this.bold = bold;
        this.italic = italic;
        this.underLine = underLine;
        this.color = color;
        this.size = size;
        this.name = name;
        Dispatch font = Dispatch.get(selection, "Font").toDispatch();
        Dispatch.put(font, "Name", new Variant(name));
        Dispatch.put(font, "Bold", new Variant(bold));
        Dispatch.put(font, "Italic", new Variant(italic));
        Dispatch.put(font, "Underline", new Variant(underLine));
        Dispatch.put(font, "Color", color);
        Dispatch.put(font, "Size", size);
    }

    /** */
    /**
     * 设置当前选定内容的字体
     * 
     * @param boldSize
     * @param italicSize
     * @param underLineSize
     *            下划线
     * @param color
     *            字体颜色
     * @param size
     *            字体大小
     * @param name
     *            字体名称
     */
    public void setFontLocal(boolean bold, boolean italic, boolean underLine, String color, String size, String name) {
        Dispatch font = Dispatch.get(selection, "Font").toDispatch();
        Dispatch.put(font, "Name", new Variant(name));
        Dispatch.put(font, "Bold", new Variant(bold));
        Dispatch.put(font, "Italic", new Variant(italic));
        Dispatch.put(font, "Underline", new Variant(underLine));
        Dispatch.put(font, "Color", color);
        Dispatch.put(font, "Size", size);
    }

    public void setFontCenter(String name) {
        Dispatch font = Dispatch.get(selection, "Font").toDispatch();
        Dispatch alignment = Dispatch.get(selection, "ParagraphFormat").toDispatch();
        Dispatch.put(alignment, "Alignment", "3");
        Dispatch.call(selection, "TypeText", name);
    }

    /**
    * 对当前段落进行格式化
    * 
    * @param align
    * 设置排列方式 默认：居左 0:居左 1:居中 2:居右 3:两端对齐 4:分散对齐
    * @param lineSpace
    * 设置行间距 默认：1.0 0：1.0 1：1.5 2：2.0 3：最小值 4：固定值
    */
    public void setParaFormat(int align, int lineSpace) {
        this.align = align;
        this.lineSpace = lineSpace;
        Dispatch selection = Dispatch.get(word, "Selection").toDispatch();
        if (align < 0 || align > 4) {
            align = 0;
        }
        if (lineSpace < 0 || lineSpace > 4) {
            lineSpace = 0;
        }
        Dispatch alignment = Dispatch.get(selection, "ParagraphFormat").toDispatch();
        Dispatch.put(alignment, "Alignment", align);
        Dispatch.put(alignment, "LineSpacingRule", new Variant(lineSpace));
    }

    /**
     * 对当前段落进行格式化
     * 
     * @param align
     * 设置排列方式 默认：居左 0:居左 1:居中 2:居右 3:两端对齐 4:分散对齐
     * @param lineSpace
     * 设置行间距 默认：1.0 0：1.0 1：1.5 2：2.0 3：最小值 4：固定值
     */
    public void setParaFormatLocal(int align, int lineSpace) {
        Dispatch selection = Dispatch.get(word, "Selection").toDispatch();
        if (align < 0 || align > 4) {
            align = 0;
        }
        if (lineSpace < 0 || lineSpace > 4) {
            lineSpace = 0;
        }
        Dispatch alignment = Dispatch.get(selection, "ParagraphFormat").toDispatch();
        Dispatch.put(alignment, "Alignment", align);
        Dispatch.put(alignment, "LineSpacingRule", new Variant(lineSpace));
    }

    //
    // 构造方法 生成activeX组件和一个文档doc组件
    //
    public void WordBean() {
        if (word == null) {

            word = new ActiveXComponent("Word.Application");
            word.setProperty("Visible", new Variant(false));
        }
        if (documents == null) {
            documents = word.getProperty("Documents").toDispatch();
        }
    }

}